Pro SQL Server Always On Availability Groups by Uttam Parui & Vivek Sanil

Author:Uttam Parui & Vivek Sanil
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

As shown in Figure 10-2, you can configure multiple secondary replicas, each of which can be used for read-only workload and/or backups and/or DBCC integrity checks. The secondary can be either in synchronous-commit mode or asynchronous-commit mode for using it as an Active Secondary .

Note

We cover the Secondary Replica on Microsoft Azure later in chapter 18.

How to Configure Readable Secondary

You can configure connection access on a Secondary Replica of an Availability Group in SQL Server by using SQL Server Management Studio , Transact-SQL, or PowerShell. The settings can be selected during Availability Group creation itself or after by altering the Availability Group.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.